UPDATE PLU
SET COST = 0,
    PRICE = 0,
    VENDNAME = '',
    AVG_COST = 0,
    OH_QTY = 0,
    SALE_PRICE = 0,
    VENDOR = '',
    REORD_LVL = '',
    REORD_QTY = '',
    LANDEDCOST = 0,
    LS_DATE = NULL,
    LP_DATE = NULL,
    ORIGPRICE = 0,
    DISC_PERC = 0,
    TYPE = 0
WHERE TYPE >= 1 AND TYPE <= 5